﻿CREATE TABLE [dbo].[ClinRecipeExecuteInfo]
(
	[Id] INT NOT NULL PRIMARY KEY IDENTITY,
	[ClinRecipeId] INT NULL, 
	[HosPayId] NVARCHAR(50) NULL,
    [RecipeIds] NVARCHAR(50) NULL, 
    [DeptHisCode] NVARCHAR(50) NULL, 
    [DeptName] NVARCHAR(50) NULL, 
    [ExecType] NVARCHAR(50) NULL, 
    [Message] NVARCHAR(50) NULL,
)

GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'本次缴费的处方的唯一编号序列,多张处方号之间用逗号分隔',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'ClinRecipeExecuteInfo',
    @level2type = N'COLUMN',
    @level2name = N'RecipeIds'
GO

EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'执行类别:取药/治疗/检查/检验',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'ClinRecipeExecuteInfo',
    @level2type = N'COLUMN',
    @level2name = N'ExecType'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'执行信息',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'ClinRecipeExecuteInfo',
    @level2type = N'COLUMN',
    @level2name = N'Message'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'科室',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'ClinRecipeExecuteInfo',
    @level2type = N'COLUMN',
    @level2name = N'DeptName'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'科室代码',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'ClinRecipeExecuteInfo',
    @level2type = N'COLUMN',
    @level2name = N'DeptHisCode'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'ClinRecipe.Id',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'ClinRecipeExecuteInfo',
    @level2type = N'COLUMN',
    @level2name = N'ClinRecipeId'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'主键，自增长',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'ClinRecipeExecuteInfo',
    @level2type = N'COLUMN',
    @level2name = N'Id'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'缴费流水号',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'ClinRecipeExecuteInfo',
    @level2type = N'COLUMN',
    @level2name = N'HosPayId'